create procedure [dbo].[BAEEventValidateRegistrantQuestions] @RegistrationID varchar(50),
     @EventCode varchar(50) as
DECLARE @Valid int, @QID int
    SET @Valid = 0;

    SELECT @QID = EventSetupQuestionID
    FROM EventSetupQuestion
    WHERE Required = 1 AND EventCode = @EventCode AND FunctionCode = 'General' AND EventSetupQuestionID NOT IN(
        SELECT QuestionID
        FROM EventRegistrationAnswer
        WHERE RegistrantID = @RegistrationID AND EventCode = @EventCode AND LEN(Answer) > 0)

    IF @@ROWCOUNT > 0
        SET @Valid = 1;

    SELECT @Valid AS 'Validated'

GO